package com.test.group6.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import com.test.group6.domain.WorkesInformation;
/**
 * 
 * Title: WorkersDao.java
  Description:企业高管信息维护DAO接口层
 * @author leng_qqing
 * @date 2021年7月23日
 * @version 1.0
 */
@Mapper
public interface DeleteWorkesMapper {
	/**
	 *@Description: 删除企业高管基本信息
	 *@param enterpriseId 企业编号
	 *@return {@link Integer}
	 */
	@Delete("DELETE FROM workes_information WHERE enterprise_id = #{enterpriseId}")
	int deleteWorkesByEnterpriseId(String enterpriseId);
	/**
	 *@Description: 删除企业高管基本信息
	 *@param workesId 高管编号
	 *@return {@link Integer}
	 */
	@Delete("DELETE FROM workes_information WHERE id = #{workerId}")
	int deleteWorkesById(String workesId);
	/**
	 *@Description: 查询企业高管基本信息
	 *@param enterpriseId 企业编号
	 *@return {@link List<WorkesInformation>}
	 */
	@Select("SELECT * FROM workes_information WHERE enterprise_id = #{enterpriseId}")
	List<WorkesInformation> selectWorkes(String enterpriseId);
	

}
